package cn.gson.boot.model.mapper;

import cn.gson.boot.model.pojos.*;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface QuotationMapper {

    //查询报价列表
    public List<Quotation> selectQuotation(@Param("search") String search,
                                           @Param("empName") String empName);

    //查询需要修改的报价单
    public List<Quotation> selectQuotationId(@Param("quotationId") Integer quotationId);

    //查询报价单号
    public String selectOdd();

    //报价单客户列表
    public List<Kehu> selectKehu(@Param("khsearch") String khsearch,
                                 @Param("empName") String empName);

    //客户联系人列表
    public List<Contacts> selectLxr(@Param("khName") String khName);

    //对应机会列表
    public List<Sales> selectSales(@Param("khName") String khName);

    //查询已签合同的报价单不能删除
    public Quotation selectHt(@Param("quotationId") Integer quotationId);

    //查询需要打印的报价单
    public Quotation selectContacts(@Param("quotationId") Integer quotationId,
                                 @Param("name") String name);

    //销售机会页面已生成报价单不可删除
    List<Quotation> selectSalesQuotation(Integer salesId);


}
